So I love the idea that we can validate our data again get clean.
Did it end because we're validating it as the users are inputting the data which means we get clean
data out of the system as well.
Now we noticed earlier when you input something that does not comply with the validation.
For example if I come back down here and changes from Chevy to Porsche in my enter key or tab key whatever
I get an error message.
Now this is the default error message that comes out of the Excel validation tool and all it says is
hey the value enter is not valid.
A User's restricted values will create us as the developer of the validation rules.
We can also specify our own custom errors.
This way we can perhaps get a little more explicit and descriptive to our users or we can have a little
fun with their users and giving them some wacky error messages that they can interpret themselves.
But either way we can create our own custom errors.
Take a look.
So first step I need to select the cells that I'm validating.
So for me I'm going to go from before down to be 30 that's the same group of cells that I did in the
previous lecture when I created the dropdown list the custom validation.
So that's all I did.
I'll go back to data back to Data Validation back to Data Validation again and this time you can see
I still have my settings in there my list with those four options.
I'm going to go over to the error of alert tab on the error alert tab.
I can see that it is going to show an error after invalidate is entered.
But remember it's the default one so I may create my own.
First I'll give it a title.
I'll just call this car make and that will be at the top of the the error window colleague who says
Data Validation up here but we'll get carmaker on ours and our error message.
So this will be the error that gets spit out to the user when they do something wrong.
So I could be really silly about it and I could say something like try again you know that on that's
it.
Or you say you bonehead you did it wrong or whatever.
Or I you get a little more descriptive with the user.
Like you say something like let's see you ma with me I'll say you entered an incorrect make Please select
a valid make from the dropdown menu.
Yada yada yada.
You don't really explain it to us.
So I read this quote once and I remember who said it I think it was just actually something thrown on
on a social media page somewhere that talked about the addition of data like this or creating systems
for users to work in an input data.
You want to make it as simple as possible.
You essentially want to do the work for them.
They input data validation All right there.
Explain to them what they did wrong.
Right.
Exactly what they did wrong so that they can fix it and they're not sitting at your desk by having you
do it or you're not holding their hand.
Help them out as much as possible.
So if I hit OK I'm going to cut back out here with put in something that doesn't exist.
I I'll say of course once again hit my enter key.
And now I've got my custom error.
You entered an incorrect make Please select a valid make from the dropdown menu.
OK I'll retry.
And now I go the dropdown retry let's get rid of that or the drop down and I can pick something valid
.
So customize not only as the validation but help your users out.
Explain to them exactly what they did wrong and what they need to do.
The steps that they need to do to fix the problem.
If you don't describe to them what they need to do the next thing you know you're going to have a line
at your desk people asking you hey I'm getting an error.
What's going on here.
How come I can't put portion here.
Now I got to explain to each individual person at my desk what's going on.
So tell now.
Tell me right there custom air.
Select the range of cells go to data go to data about Asian and do your custom heir's